Cloudscape

To create a Cloudscape SQL database service endpoint:

  1. On the Service Endpoints | Add Service Endpoint | Edit Service Endpoint endpoint_name page, enter the Properties for the SQL database service endpoint.

The Cloudscape service endpoint properties are:

    1. Database Path - The full name of the database and the directory where it will be created.

    2. Schema -

    3. Requires Authentication - If this option is selected, .

    4. User - A user name that will be created when the database is created.

Note: Once this user name has been defined in the Process Administrator, the name cannot be changed. If a new administrative user name is necessary, create a new service endpoint that uses the new user name.

    1. Password - A password that will be created for the user when the database is created.

  1. On the Service Endpoints | Add Service Endpoint | Edit Service Endpoint endpoint_name page, configure the following Runtime options for the SQL database service endpoint or accept the defaults:

    1. Maximum Pool Size - Enter the maximum number of connections that the pool can allocate. The pool will never create more connections than this limit imposes. The default is 10.

    2. Connection Idle Time (Mins) - Enter the amount of time the database connection can remain idle before the connection is dropped. The default is 5 minutes.

    3. Maximum Opened Cursors - Enter the maximum number of opened cursors allowed on the database. The default is 50. This value is related to the maximum pool size. The number of cursors is divided in between the number of maximum pool size and each connection will manage that number of cursors. For example, if you have 500 maximum opened cursors and the maximum pool size is 50, each connection can have a maximum of 10 opened cursors.

  2. Click Save.